Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	51290
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.2 MiB
Average record size in memory	168.0 B

Variable types

Text	6
Unsupported	2
Categorical	8
Numeric	5

Alerts

`category` is highly overall correlated with `sub_category`	High correlation
`discount` is highly overall correlated with `profit`	High correlation
`market` is highly overall correlated with `region`	High correlation
`profit` is highly overall correlated with `discount`	High correlation
`region` is highly overall correlated with `market`	High correlation
`sales` is highly overall correlated with `shipping_cost`	High correlation
`shipping_cost` is highly overall correlated with `sales`	High correlation
`sub_category` is highly overall correlated with `category`	High correlation
`order_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ship_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`discount` has 29009 (56.6%) zeros	Zeros
`profit` has 668 (1.3%) zeros	Zeros

Reproduction

Analysis started	2025-10-14 07:21:58.630641
Analysis finished	2025-10-14 07:22:14.799347
Duration	16.17 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

order_id
Text

Distinct	25035
Distinct (%)	48.8%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Length

Max length	15
Median length	14
Mean length	13.569643
Min length	9

Characters and Unicode

Total characters	695987
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12257 ?
Unique (%)	23.9%

Sample

1st row	AG-2011-2040
2nd row	IN-2011-47883
3rd row	HU-2011-1220
4th row	IT-2011-3647632
5th row	IN-2011-47883

Value	Count	Frequency (%)
ca-2014-100111	14	< 0.1%
to-2014-9950	13	< 0.1%
ni-2014-8880	13	< 0.1%
in-2013-42311	13	< 0.1%
in-2012-41261	13	< 0.1%
mx-2014-166541	13	< 0.1%
in-2011-76625	12	< 0.1%
es-2012-5776825	12	< 0.1%
in-2014-15263	12	< 0.1%
mx-2013-142678	12	< 0.1%
Other values (25025)	51163	99.8%

Most occurring characters

Value	Count	Frequency (%)
1	108762	15.6%
-	102580	14.7%
2	90147	13.0%
0	85011	12.2%
4	45213	6.5%
3	41592	6.0%
5	27294	3.9%
6	25799	3.7%
7	23086	3.3%
8	22626	3.3%
Other values (27)	123877	17.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	695987	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	108762	15.6%
-	102580	14.7%
2	90147	13.0%
0	85011	12.2%
4	45213	6.5%
3	41592	6.0%
5	27294	3.9%
6	25799	3.7%
7	23086	3.3%
8	22626	3.3%
Other values (27)	123877	17.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	695987	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	108762	15.6%
-	102580	14.7%
2	90147	13.0%
0	85011	12.2%
4	45213	6.5%
3	41592	6.0%
5	27294	3.9%
6	25799	3.7%
7	23086	3.3%
8	22626	3.3%
Other values (27)	123877	17.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	695987	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	108762	15.6%
-	102580	14.7%
2	90147	13.0%
0	85011	12.2%
4	45213	6.5%
3	41592	6.0%
5	27294	3.9%
6	25799	3.7%
7	23086	3.3%
8	22626	3.3%
Other values (27)	123877	17.8%

order_date
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

ship_date
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

ship_mode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Standard Class	30775
Second Class	10309
First Class	7505
Same Day	2701

Length

Max length	14
Median length	14
Mean length	12.843069
Min length	8

Characters and Unicode

Total characters	658721
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Standard Class
2nd row	Standard Class
3rd row	Second Class
4th row	Second Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	30775	60.0%
Second Class	10309	20.1%
First Class	7505	14.6%
Same Day	2701	5.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	48589	47.4%
standard	30775	30.0%
second	10309	10.0%
first	7505	7.3%
same	2701	2.6%
day	2701	2.6%

Most occurring characters

Value	Count	Frequency (%)
a	115541	17.5%
s	104683	15.9%
d	71859	10.9%
	51290	7.8%
l	48589	7.4%
C	48589	7.4%
S	43785	6.6%
n	41084	6.2%
r	38280	5.8%
t	38280	5.8%
Other values (8)	56741	8.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	658721	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	115541	17.5%
s	104683	15.9%
d	71859	10.9%
	51290	7.8%
l	48589	7.4%
C	48589	7.4%
S	43785	6.6%
n	41084	6.2%
r	38280	5.8%
t	38280	5.8%
Other values (8)	56741	8.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	658721	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	115541	17.5%
s	104683	15.9%
d	71859	10.9%
	51290	7.8%
l	48589	7.4%
C	48589	7.4%
S	43785	6.6%
n	41084	6.2%
r	38280	5.8%
t	38280	5.8%
Other values (8)	56741	8.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	658721	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	115541	17.5%
s	104683	15.9%
d	71859	10.9%
	51290	7.8%
l	48589	7.4%
C	48589	7.4%
S	43785	6.6%
n	41084	6.2%
r	38280	5.8%
t	38280	5.8%
Other values (8)	56741	8.6%

customer_name
Text

Distinct	795
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Length

Max length	22
Median length	18
Mean length	12.946227
Min length	7

Characters and Unicode

Total characters	664012
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Toby Braunhardt
2nd row	Joseph Holt
3rd row	Annie Thurman
4th row	Eugene Moren
5th row	Joseph Holt

Value	Count	Frequency (%)
michael	655	0.6%
john	522	0.5%
paul	438	0.4%
patrick	437	0.4%
tom	430	0.4%
stewart	426	0.4%
anthony	424	0.4%
frank	422	0.4%
bill	402	0.4%
alan	402	0.4%
Other values (901)	98324	95.6%

Most occurring characters

Value	Count	Frequency (%)
a	61455	9.3%
e	60921	9.2%
n	51801	7.8%
	51592	7.8%
r	48359	7.3%
i	40342	6.1%
l	34229	5.2%
o	30793	4.6%
t	27197	4.1%
s	23187	3.5%
Other values (47)	234136	35.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	664012	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	61455	9.3%
e	60921	9.2%
n	51801	7.8%
	51592	7.8%
r	48359	7.3%
i	40342	6.1%
l	34229	5.2%
o	30793	4.6%
t	27197	4.1%
s	23187	3.5%
Other values (47)	234136	35.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	664012	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	61455	9.3%
e	60921	9.2%
n	51801	7.8%
	51592	7.8%
r	48359	7.3%
i	40342	6.1%
l	34229	5.2%
o	30793	4.6%
t	27197	4.1%
s	23187	3.5%
Other values (47)	234136	35.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	664012	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	61455	9.3%
e	60921	9.2%
n	51801	7.8%
	51592	7.8%
r	48359	7.3%
i	40342	6.1%
l	34229	5.2%
o	30793	4.6%
t	27197	4.1%
s	23187	3.5%
Other values (47)	234136	35.3%

segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Consumer	26518
Corporate	15429
Home Office	9343

Length

Max length	11
Median length	8
Mean length	8.8472997
Min length	8

Characters and Unicode

Total characters	453778
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Consumer
4th row	Home Office
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Consumer	26518	51.7%
Corporate	15429	30.1%
Home Office	9343	18.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	26518	43.7%
corporate	15429	25.4%
home	9343	15.4%
office	9343	15.4%

Most occurring characters

Value	Count	Frequency (%)
o	66719	14.7%
e	60633	13.4%
r	57376	12.6%
C	41947	9.2%
m	35861	7.9%
n	26518	5.8%
s	26518	5.8%
u	26518	5.8%
f	18686	4.1%
t	15429	3.4%
Other values (7)	77573	17.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	453778	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	66719	14.7%
e	60633	13.4%
r	57376	12.6%
C	41947	9.2%
m	35861	7.9%
n	26518	5.8%
s	26518	5.8%
u	26518	5.8%
f	18686	4.1%
t	15429	3.4%
Other values (7)	77573	17.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	453778	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	66719	14.7%
e	60633	13.4%
r	57376	12.6%
C	41947	9.2%
m	35861	7.9%
n	26518	5.8%
s	26518	5.8%
u	26518	5.8%
f	18686	4.1%
t	15429	3.4%
Other values (7)	77573	17.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	453778	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	66719	14.7%
e	60633	13.4%
r	57376	12.6%
C	41947	9.2%
m	35861	7.9%
n	26518	5.8%
s	26518	5.8%
u	26518	5.8%
f	18686	4.1%
t	15429	3.4%
Other values (7)	77573	17.1%

state
Text

Distinct	1094
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Length

Max length	36
Median length	26
Mean length	9.6409826
Min length	3

Characters and Unicode

Total characters	494486
Distinct characters	81
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	64 ?
Unique (%)	0.1%

Sample

1st row	Constantine
2nd row	New South Wales
3rd row	Budapest
4th row	Stockholm
5th row	New South Wales

Value	Count	Frequency (%)
california	2125	3.1%
new	2103	3.1%
england	1499	2.2%
south	1201	1.8%
north	1145	1.7%
york	1128	1.7%
texas	985	1.4%
ile-de-france	981	1.4%
wales	817	1.2%
capital	784	1.1%
Other values (1189)	55429	81.3%

Most occurring characters

Value	Count	Frequency (%)
a	72974	14.8%
n	39413	8.0%
i	33410	6.8%
e	30993	6.3%
o	28369	5.7%
r	28361	5.7%
l	23890	4.8%
t	21263	4.3%
s	19509	3.9%
	16907	3.4%
Other values (71)	179397	36.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	494486	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	72974	14.8%
n	39413	8.0%
i	33410	6.8%
e	30993	6.3%
o	28369	5.7%
r	28361	5.7%
l	23890	4.8%
t	21263	4.3%
s	19509	3.9%
	16907	3.4%
Other values (71)	179397	36.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	494486	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	72974	14.8%
n	39413	8.0%
i	33410	6.8%
e	30993	6.3%
o	28369	5.7%
r	28361	5.7%
l	23890	4.8%
t	21263	4.3%
s	19509	3.9%
	16907	3.4%
Other values (71)	179397	36.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	494486	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	72974	14.8%
n	39413	8.0%
i	33410	6.8%
e	30993	6.3%
o	28369	5.7%
r	28361	5.7%
l	23890	4.8%
t	21263	4.3%
s	19509	3.9%
	16907	3.4%
Other values (71)	179397	36.3%

country
Text

Distinct	147
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Length

Max length	32
Median length	22
Mean length	8.8366738
Min length	4

Characters and Unicode

Total characters	453233
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Algeria
2nd row	Australia
3rd row	Hungary
4th row	Sweden
5th row	Australia

Value	Count	Frequency (%)
united	11641	17.1%
states	9994	14.7%
australia	2837	4.2%
france	2827	4.2%
mexico	2644	3.9%
germany	2065	3.0%
china	1880	2.8%
kingdom	1633	2.4%
brazil	1599	2.3%
india	1555	2.3%
Other values (154)	29420	43.2%

Most occurring characters

Value	Count	Frequency (%)
a	55137	12.2%
e	43176	9.5%
i	40575	9.0%
t	40485	8.9%
n	36881	8.1%
d	21302	4.7%
r	20390	4.5%
s	18355	4.0%
	16805	3.7%
o	14461	3.2%
Other values (44)	145666	32.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	453233	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	55137	12.2%
e	43176	9.5%
i	40575	9.0%
t	40485	8.9%
n	36881	8.1%
d	21302	4.7%
r	20390	4.5%
s	18355	4.0%
	16805	3.7%
o	14461	3.2%
Other values (44)	145666	32.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	453233	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	55137	12.2%
e	43176	9.5%
i	40575	9.0%
t	40485	8.9%
n	36881	8.1%
d	21302	4.7%
r	20390	4.5%
s	18355	4.0%
	16805	3.7%
o	14461	3.2%
Other values (44)	145666	32.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	453233	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	55137	12.2%
e	43176	9.5%
i	40575	9.0%
t	40485	8.9%
n	36881	8.1%
d	21302	4.7%
r	20390	4.5%
s	18355	4.0%
	16805	3.7%
o	14461	3.2%
Other values (44)	145666	32.1%

market
Categorical

High correlation

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

APAC	11002
LATAM	10294
EU	10000
US	9994
EMEA	5029
Other values (2)	4971

Length

Max length	6
Median length	5
Mean length	3.6148957
Min length	2

Characters and Unicode

Total characters	185408
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Africa
2nd row	APAC
3rd row	EMEA
4th row	EU
5th row	APAC

Common Values

Value	Count	Frequency (%)
APAC	11002	21.5%
LATAM	10294	20.1%
EU	10000	19.5%
US	9994	19.5%
EMEA	5029	9.8%
Africa	4587	8.9%
Canada	384	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
apac	11002	21.5%
latam	10294	20.1%
eu	10000	19.5%
us	9994	19.5%
emea	5029	9.8%
africa	4587	8.9%
canada	384	0.7%

Most occurring characters

Value	Count	Frequency (%)
A	52208	28.2%
E	20058	10.8%
U	19994	10.8%
M	15323	8.3%
C	11386	6.1%
P	11002	5.9%
L	10294	5.6%
T	10294	5.6%
S	9994	5.4%
a	5739	3.1%
Other values (6)	19116	10.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	185408	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	52208	28.2%
E	20058	10.8%
U	19994	10.8%
M	15323	8.3%
C	11386	6.1%
P	11002	5.9%
L	10294	5.6%
T	10294	5.6%
S	9994	5.4%
a	5739	3.1%
Other values (6)	19116	10.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	185408	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	52208	28.2%
E	20058	10.8%
U	19994	10.8%
M	15323	8.3%
C	11386	6.1%
P	11002	5.9%
L	10294	5.6%
T	10294	5.6%
S	9994	5.4%
a	5739	3.1%
Other values (6)	19116	10.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	185408	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	52208	28.2%
E	20058	10.8%
U	19994	10.8%
M	15323	8.3%
C	11386	6.1%
P	11002	5.9%
L	10294	5.6%
T	10294	5.6%
S	9994	5.4%
a	5739	3.1%
Other values (6)	19116	10.3%

region
Categorical

High correlation

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Central	11117
South	6645
EMEA	5029
North	4785
Africa	4587
Other values (8)	19127

Length

Max length	14
Median length	12
Mean length	6.638643
Min length	4

Characters and Unicode

Total characters	340496
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Africa
2nd row	Oceania
3rd row	EMEA
4th row	North
5th row	Oceania

Common Values

Value	Count	Frequency (%)
Central	11117	21.7%
South	6645	13.0%
EMEA	5029	9.8%
North	4785	9.3%
Africa	4587	8.9%
Oceania	3487	6.8%
West	3203	6.2%
Southeast Asia	3129	6.1%
East	2848	5.6%
North Asia	2338	4.6%
Other values (3)	4122	8.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
central	13165	22.4%
asia	7515	12.8%
north	7123	12.1%
south	6645	11.3%
emea	5029	8.6%
africa	4587	7.8%
oceania	3487	5.9%
west	3203	5.4%
southeast	3129	5.3%
east	2848	4.8%
Other values (2)	2074	3.5%

Most occurring characters

Value	Count	Frequency (%)
a	42750	12.6%
t	39242	11.5%
r	26565	7.8%
e	24674	7.2%
n	18726	5.5%
i	17279	5.1%
A	17131	5.0%
o	16897	5.0%
h	16897	5.0%
s	16695	4.9%
Other values (14)	103640	30.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	340496	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	42750	12.6%
t	39242	11.5%
r	26565	7.8%
e	24674	7.2%
n	18726	5.5%
i	17279	5.1%
A	17131	5.0%
o	16897	5.0%
h	16897	5.0%
s	16695	4.9%
Other values (14)	103640	30.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	340496	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	42750	12.6%
t	39242	11.5%
r	26565	7.8%
e	24674	7.2%
n	18726	5.5%
i	17279	5.1%
A	17131	5.0%
o	16897	5.0%
h	16897	5.0%
s	16695	4.9%
Other values (14)	103640	30.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	340496	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	42750	12.6%
t	39242	11.5%
r	26565	7.8%
e	24674	7.2%
n	18726	5.5%
i	17279	5.1%
A	17131	5.0%
o	16897	5.0%
h	16897	5.0%
s	16695	4.9%
Other values (14)	103640	30.4%

product_id
Text

Distinct	10292
Distinct (%)	20.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Length

Max length	16
Median length	15
Mean length	15.195009
Min length	15

Characters and Unicode

Total characters	779352
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1420 ?
Unique (%)	2.8%

Sample

1st row	OFF-TEN-10000025
2nd row	OFF-SU-10000618
3rd row	OFF-TEN-10001585
4th row	OFF-PA-10001492
5th row	FUR-FU-10003447

Value	Count	Frequency (%)
tec-hp	83	0.2%
off-ar-10003651	35	0.1%
off-ar-10003829	31	0.1%
off-bi-10002799	30	0.1%
off-bi-10003708	30	0.1%
fur-ch-10003354	28	0.1%
off-bi-10002570	27	0.1%
off-bi-10004140	25	< 0.1%
off-bi-10004632	24	< 0.1%
off-bi-10001808	24	< 0.1%
Other values (10283)	51036	99.3%

Most occurring characters

Value	Count	Frequency (%)
0	179614	23.0%
-	102580	13.2%
F	77961	10.0%
1	77220	9.9%
O	37143	4.8%
2	25593	3.3%
3	25555	3.3%
4	25148	3.2%
A	20235	2.6%
C	19282	2.5%
Other values (25)	189021	24.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	779352	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	179614	23.0%
-	102580	13.2%
F	77961	10.0%
1	77220	9.9%
O	37143	4.8%
2	25593	3.3%
3	25555	3.3%
4	25148	3.2%
A	20235	2.6%
C	19282	2.5%
Other values (25)	189021	24.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	779352	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	179614	23.0%
-	102580	13.2%
F	77961	10.0%
1	77220	9.9%
O	37143	4.8%
2	25593	3.3%
3	25555	3.3%
4	25148	3.2%
A	20235	2.6%
C	19282	2.5%
Other values (25)	189021	24.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	779352	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	179614	23.0%
-	102580	13.2%
F	77961	10.0%
1	77220	9.9%
O	37143	4.8%
2	25593	3.3%
3	25555	3.3%
4	25148	3.2%
A	20235	2.6%
C	19282	2.5%
Other values (25)	189021	24.3%

category
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Office Supplies	31273
Technology	10141
Furniture	9876

Length

Max length	15
Median length	15
Mean length	12.856093
Min length	9

Characters and Unicode

Total characters	659389
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Office Supplies
2nd row	Office Supplies
3rd row	Office Supplies
4th row	Office Supplies
5th row	Furniture

Common Values

Value	Count	Frequency (%)
Office Supplies	31273	61.0%
Technology	10141	19.8%
Furniture	9876	19.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	31273	37.9%
supplies	31273	37.9%
technology	10141	12.3%
furniture	9876	12.0%

Most occurring characters

Value	Count	Frequency (%)
e	82563	12.5%
i	72422	11.0%
p	62546	9.5%
f	62546	9.5%
u	51025	7.7%
c	41414	6.3%
l	41414	6.3%
O	31273	4.7%
s	31273	4.7%
S	31273	4.7%
Other values (10)	151640	23.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	659389	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	82563	12.5%
i	72422	11.0%
p	62546	9.5%
f	62546	9.5%
u	51025	7.7%
c	41414	6.3%
l	41414	6.3%
O	31273	4.7%
s	31273	4.7%
S	31273	4.7%
Other values (10)	151640	23.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	659389	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	82563	12.5%
i	72422	11.0%
p	62546	9.5%
f	62546	9.5%
u	51025	7.7%
c	41414	6.3%
l	41414	6.3%
O	31273	4.7%
s	31273	4.7%
S	31273	4.7%
Other values (10)	151640	23.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	659389	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	82563	12.5%
i	72422	11.0%
p	62546	9.5%
f	62546	9.5%
u	51025	7.7%
c	41414	6.3%
l	41414	6.3%
O	31273	4.7%
s	31273	4.7%
S	31273	4.7%
Other values (10)	151640	23.0%

sub_category
Categorical

High correlation

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Binders	6152
Storage	5059
Art	4883
Paper	3538
Chairs	3434
Other values (12)	28224

Length

Max length	11
Median length	9
Mean length	7.2304933
Min length	3

Characters and Unicode

Total characters	370852
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Storage
2nd row	Supplies
3rd row	Storage
4th row	Paper
5th row	Furnishings

Common Values

Value	Count	Frequency (%)
Binders	6152	12.0%
Storage	5059	9.9%
Art	4883	9.5%
Paper	3538	6.9%
Chairs	3434	6.7%
Phones	3357	6.5%
Furnishings	3170	6.2%
Accessories	3075	6.0%
Labels	2606	5.1%
Envelopes	2435	4.7%
Other values (7)	13581	26.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
binders	6152	12.0%
storage	5059	9.9%
art	4883	9.5%
paper	3538	6.9%
chairs	3434	6.7%
phones	3357	6.5%
furnishings	3170	6.2%
accessories	3075	6.0%
labels	2606	5.1%
envelopes	2435	4.7%
Other values (7)	13581	26.5%

Most occurring characters

Value	Count	Frequency (%)
s	51961	14.0%
e	47733	12.9%
r	33954	9.2%
i	26890	7.3%
n	23945	6.5%
a	23570	6.4%
o	20971	5.7%
p	16556	4.5%
t	12362	3.3%
c	11802	3.2%
Other values (18)	101108	27.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	370852	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	51961	14.0%
e	47733	12.9%
r	33954	9.2%
i	26890	7.3%
n	23945	6.5%
a	23570	6.4%
o	20971	5.7%
p	16556	4.5%
t	12362	3.3%
c	11802	3.2%
Other values (18)	101108	27.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	370852	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	51961	14.0%
e	47733	12.9%
r	33954	9.2%
i	26890	7.3%
n	23945	6.5%
a	23570	6.4%
o	20971	5.7%
p	16556	4.5%
t	12362	3.3%
c	11802	3.2%
Other values (18)	101108	27.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	370852	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	51961	14.0%
e	47733	12.9%
r	33954	9.2%
i	26890	7.3%
n	23945	6.5%
a	23570	6.4%
o	20971	5.7%
p	16556	4.5%
t	12362	3.3%
c	11802	3.2%
Other values (18)	101108	27.3%

product_name
Text

Distinct	3788
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Length

Max length	127
Median length	89
Mean length	30.856931
Min length	5

Characters and Unicode

Total characters	1582652
Distinct characters	85
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	98 ?
Unique (%)	0.2%

Sample

1st row	Tenex Lockers, Blue
2nd row	Acme Trimmer, High Speed
3rd row	Tenex Box, Single Width
4th row	Enermax Note Cards, Premium
5th row	Eldon Light Bulb, Duo Pack

Value	Count	Frequency (%)
labels	2385	1.0%
recycled	2291	1.0%
color	2187	0.9%
with	2177	0.9%
set	2106	0.9%
blue	2092	0.9%
durable	2072	0.9%
black	2055	0.9%
avery	1920	0.8%
clear	1893	0.8%
Other values (2826)	210320	90.9%

Most occurring characters

Value	Count	Frequency (%)
	179838	11.4%
e	154618	9.8%
a	94421	6.0%
r	91563	5.8%
o	88370	5.6%
l	79902	5.0%
i	79392	5.0%
n	68089	4.3%
t	62491	3.9%
s	60638	3.8%
Other values (75)	623330	39.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1582652	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	179838	11.4%
e	154618	9.8%
a	94421	6.0%
r	91563	5.8%
o	88370	5.6%
l	79902	5.0%
i	79392	5.0%
n	68089	4.3%
t	62491	3.9%
s	60638	3.8%
Other values (75)	623330	39.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1582652	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	179838	11.4%
e	154618	9.8%
a	94421	6.0%
r	91563	5.8%
o	88370	5.6%
l	79902	5.0%
i	79392	5.0%
n	68089	4.3%
t	62491	3.9%
s	60638	3.8%
Other values (75)	623330	39.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1582652	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	179838	11.4%
e	154618	9.8%
a	94421	6.0%
r	91563	5.8%
o	88370	5.6%
l	79902	5.0%
i	79392	5.0%
n	68089	4.3%
t	62491	3.9%
s	60638	3.8%
Other values (75)	623330	39.4%

sales
Real number (ℝ)

High correlation

Distinct	2246
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	246.49844

Minimum	0
Maximum	22638
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	400.8 KiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	31
median	85
Q3	251
95-th percentile	1016
Maximum	22638
Range	22638
Interquartile range (IQR)	220

Descriptive statistics

Standard deviation	487.56717
Coefficient of variation (CV)	1.9779727
Kurtosis	176.72302
Mean	246.49844
Median Absolute Deviation (MAD)	67
Skewness	8.1379805
Sum	12642905
Variance	237721.75
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	589	1.1%
11	550	1.1%
14	527	1.0%
19	523	1.0%
17	520	1.0%
15	518	1.0%
12	512	1.0%
16	505	1.0%
9	498	1.0%
22	478	0.9%
Other values (2236)	46070	89.8%

Value	Count	Frequency (%)
0	1	< 0.1%
1	44	0.1%
2	142	0.3%
3	274	0.5%
4	306	0.6%
5	372	0.7%
6	433	0.8%
7	411	0.8%
8	413	0.8%
9	498	1.0%

Value	Count	Frequency (%)
22638	1	< 0.1%
17500	1	< 0.1%
14000	1	< 0.1%
11200	1	< 0.1%
10500	1	< 0.1%
9893	1	< 0.1%
9450	1	< 0.1%
9100	1	< 0.1%
8750	1	< 0.1%
8400	1	< 0.1%

quantity
Real number (ℝ)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4765451

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	400.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	8
Maximum	14
Range	13
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2787663
Coefficient of variation (CV)	0.65546864
Kurtosis	2.2758887
Mean	3.4765451
Median Absolute Deviation (MAD)	1
Skewness	1.3603677
Sum	178312
Variance	5.1927759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	12748	24.9%
3	9682	18.9%
1	8963	17.5%
4	6385	12.4%
5	4882	9.5%
6	3020	5.9%
7	2385	4.7%
8	1361	2.7%
9	987	1.9%
10	276	0.5%
Other values (4)	601	1.2%

Value	Count	Frequency (%)
1	8963	17.5%
2	12748	24.9%
3	9682	18.9%
4	6385	12.4%
5	4882	9.5%
6	3020	5.9%
7	2385	4.7%
8	1361	2.7%
9	987	1.9%
10	276	0.5%

Value	Count	Frequency (%)
14	186	0.4%
13	83	0.2%
12	176	0.3%
11	156	0.3%
10	276	0.5%
9	987	1.9%
8	1361	2.7%
7	2385	4.7%
6	3020	5.9%
5	4882	9.5%

discount
Real number (ℝ)

High correlation Zeros

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.14290755

Minimum	0
Maximum	0.85
Zeros	29009
Zeros (%)	56.6%
Negative	0
Negative (%)	0.0%
Memory size	400.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.2
95-th percentile	0.6
Maximum	0.85
Range	0.85
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.21227993
Coefficient of variation (CV)	1.4854354
Kurtosis	0.71668241
Mean	0.14290755
Median Absolute Deviation (MAD)	0
Skewness	1.3877746
Sum	7329.728
Variance	0.045062769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	29009	56.6%
0.2	4998	9.7%
0.1	4068	7.9%
0.4	3177	6.2%
0.6	2006	3.9%
0.7	1786	3.5%
0.5	1633	3.2%
0.17	735	1.4%
0.47	725	1.4%
0.15	541	1.1%
Other values (17)	2612	5.1%

Value	Count	Frequency (%)
0	29009	56.6%
0.002	461	0.9%
0.07	150	0.3%
0.1	4068	7.9%
0.15	541	1.1%
0.17	735	1.4%
0.2	4998	9.7%
0.202	41	0.1%
0.25	198	0.4%
0.27	388	0.8%

Value	Count	Frequency (%)
0.85	2	< 0.1%
0.8	316	0.6%
0.7	1786	3.5%
0.65	17	< 0.1%
0.602	23	< 0.1%
0.6	2006	3.9%
0.57	12	< 0.1%
0.55	10	< 0.1%
0.5	1633	3.2%
0.47	725	1.4%

profit
Real number (ℝ)

High correlation Zeros

Distinct	24575
Distinct (%)	47.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.64174

Minimum	-6599.978
Maximum	8399.976
Zeros	668
Zeros (%)	1.3%
Negative	12543
Negative (%)	24.5%
Memory size	400.8 KiB

Quantile statistics

Minimum	-6599.978
5-th percentile	-83.87784
Q1	0
median	9.24
Q3	36.81
95-th percentile	211.5
Maximum	8399.976
Range	14999.954
Interquartile range (IQR)	36.81

Descriptive statistics

Standard deviation	174.42411
Coefficient of variation (CV)	6.0898575
Kurtosis	290.90013
Mean	28.64174
Median Absolute Deviation (MAD)	15.96
Skewness	4.1581878
Sum	1469034.8
Variance	30423.771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	668	1.3%
4.32	70	0.1%
3.96	69	0.1%
7.92	67	0.1%
2.64	63	0.1%
2.88	60	0.1%
6.84	57	0.1%
9	56	0.1%
0.48	55	0.1%
3.42	55	0.1%
Other values (24565)	50070	97.6%

Value	Count	Frequency (%)
-6599.978	1	< 0.1%
-4088.376	1	< 0.1%
-3839.9904	1	< 0.1%
-3701.8928	1	< 0.1%
-3399.98	1	< 0.1%
-3059.82	1	< 0.1%
-3009.435	1	< 0.1%
-2929.4845	1	< 0.1%
-2750.28	1	< 0.1%
-2639.9912	1	< 0.1%

Value	Count	Frequency (%)
8399.976	1	< 0.1%
6719.9808	1	< 0.1%
5039.9856	1	< 0.1%
4946.37	1	< 0.1%
4630.4755	1	< 0.1%
3979.08	1	< 0.1%
3919.9888	1	< 0.1%
3177.475	1	< 0.1%
2939.31	1	< 0.1%
2817.99	1	< 0.1%

shipping_cost
Real number (ℝ)

High correlation

Distinct	10037
Distinct (%)	19.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.375915

Minimum	0
Maximum	933.57
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	400.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.61
Q1	2.61
median	7.79
Q3	24.45
95-th percentile	111.4095
Maximum	933.57
Range	933.57
Interquartile range (IQR)	21.84

Descriptive statistics

Standard deviation	57.296804
Coefficient of variation (CV)	2.1723153
Kurtosis	50.020158
Mean	26.375915
Median Absolute Deviation (MAD)	6.41
Skewness	5.8632264
Sum	1352820.7
Variance	3282.9237
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.86	76	0.1%
1.26	75	0.1%
0.71	75	0.1%
1.36	74	0.1%
0.35	73	0.1%
0.79	71	0.1%
0.94	71	0.1%
1.04	71	0.1%
0.97	70	0.1%
0.69	70	0.1%
Other values (10027)	50564	98.6%

Value	Count	Frequency (%)
0	2	< 0.1%
0.01	6	< 0.1%
0.02	9	< 0.1%
0.03	9	< 0.1%
0.04	14	< 0.1%
0.05	19	< 0.1%
0.06	18	< 0.1%
0.07	13	< 0.1%
0.08	17	< 0.1%
0.09	23	< 0.1%

Value	Count	Frequency (%)
933.57	1	< 0.1%
923.63	1	< 0.1%
915.49	1	< 0.1%
910.16	1	< 0.1%
903.04	1	< 0.1%
897.35	1	< 0.1%
894.77	1	< 0.1%
878.38	1	< 0.1%
867.69	1	< 0.1%
865.74	1	< 0.1%

order_priority
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

Medium	29433
High	15501
Critical	3932
Low	2424

Length

Max length	8
Median length	6
Mean length	5.4070969
Min length	3

Characters and Unicode

Total characters	277330
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Medium
2nd row	Medium
3rd row	High
4th row	High
5th row	Medium

Common Values

Value	Count	Frequency (%)
Medium	29433	57.4%
High	15501	30.2%
Critical	3932	7.7%
Low	2424	4.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
medium	29433	57.4%
high	15501	30.2%
critical	3932	7.7%
low	2424	4.7%

Most occurring characters

Value	Count	Frequency (%)
i	52798	19.0%
M	29433	10.6%
d	29433	10.6%
u	29433	10.6%
m	29433	10.6%
e	29433	10.6%
H	15501	5.6%
g	15501	5.6%
h	15501	5.6%
c	3932	1.4%
Other values (8)	26932	9.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	277330	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	52798	19.0%
M	29433	10.6%
d	29433	10.6%
u	29433	10.6%
m	29433	10.6%
e	29433	10.6%
H	15501	5.6%
g	15501	5.6%
h	15501	5.6%
c	3932	1.4%
Other values (8)	26932	9.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	277330	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	52798	19.0%
M	29433	10.6%
d	29433	10.6%
u	29433	10.6%
m	29433	10.6%
e	29433	10.6%
H	15501	5.6%
g	15501	5.6%
h	15501	5.6%
c	3932	1.4%
Other values (8)	26932	9.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	277330	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	52798	19.0%
M	29433	10.6%
d	29433	10.6%
u	29433	10.6%
m	29433	10.6%
e	29433	10.6%
H	15501	5.6%
g	15501	5.6%
h	15501	5.6%
c	3932	1.4%
Other values (8)	26932	9.7%

year
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.8 KiB

2014	17531
2013	13799
2012	10962
2011	8998

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	205160
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2011
2nd row	2011
3rd row	2011
4th row	2011
5th row	2011

Common Values

Value	Count	Frequency (%)
2014	17531	34.2%
2013	13799	26.9%
2012	10962	21.4%
2011	8998	17.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2014	17531	34.2%
2013	13799	26.9%
2012	10962	21.4%
2011	8998	17.5%

Most occurring characters

Value	Count	Frequency (%)
2	62252	30.3%
1	60288	29.4%
0	51290	25.0%
4	17531	8.5%
3	13799	6.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	205160	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	62252	30.3%
1	60288	29.4%
0	51290	25.0%
4	17531	8.5%
3	13799	6.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	205160	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	62252	30.3%
1	60288	29.4%
0	51290	25.0%
4	17531	8.5%
3	13799	6.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	205160	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	62252	30.3%
1	60288	29.4%
0	51290	25.0%
4	17531	8.5%
3	13799	6.7%

Interactions

Correlations

	category	discount	market	order_priority	profit	quantity	region	sales	segment	ship_mode	shipping_cost	sub_category	year
category	1.000	0.185	0.073	0.003	0.056	0.015	0.056	0.062	0.000	0.000	0.156	1.000	0.002
discount	0.185	1.000	0.348	0.011	-0.596	0.018	0.335	-0.100	0.000	0.019	-0.094	0.159	0.020
market	0.073	0.348	1.000	0.013	0.010	0.157	0.882	0.021	0.009	0.014	0.032	0.128	0.028
order_priority	0.003	0.011	0.013	1.000	0.009	0.008	0.027	0.000	0.019	0.284	0.099	0.004	0.017
profit	0.056	-0.596	0.010	0.009	1.000	0.202	0.010	0.490	0.000	0.011	0.450	0.058	0.000
quantity	0.015	0.018	0.157	0.008	0.202	1.000	0.129	0.416	0.000	0.008	0.379	0.016	0.010
region	0.056	0.335	0.882	0.027	0.010	0.129	1.000	0.019	0.012	0.026	0.028	0.069	0.022
sales	0.062	-0.100	0.021	0.000	0.490	0.416	0.019	1.000	0.000	0.000	0.913	0.061	0.000
segment	0.000	0.000	0.009	0.019	0.000	0.000	0.012	0.000	1.000	0.011	0.000	0.012	0.014
ship_mode	0.000	0.019	0.014	0.284	0.011	0.008	0.026	0.000	0.011	1.000	0.074	0.011	0.007
shipping_cost	0.156	-0.094	0.032	0.099	0.450	0.379	0.028	0.913	0.000	0.074	1.000	0.112	0.014
sub_category	1.000	0.159	0.128	0.004	0.058	0.016	0.069	0.061	0.012	0.011	0.112	1.000	0.005
year	0.002	0.020	0.028	0.017	0.000	0.010	0.022	0.000	0.014	0.007	0.014	0.005	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	order_id	order_date	ship_date	ship_mode	customer_name	segment	state	country	market	region	product_id	category	sub_category	product_name	sales	quantity	discount	profit	shipping_cost	order_priority	year
0	AG-2011-2040	2011-01-01 00:00:00	2011-06-01 00:00:00	Standard Class	Toby Braunhardt	Consumer	Constantine	Algeria	Africa	Africa	OFF-TEN-10000025	Office Supplies	Storage	Tenex Lockers, Blue	408	2	0.0	106.140	35.46	Medium	2011
1	IN-2011-47883	2011-01-01 00:00:00	2011-08-01 00:00:00	Standard Class	Joseph Holt	Consumer	New South Wales	Australia	APAC	Oceania	OFF-SU-10000618	Office Supplies	Supplies	Acme Trimmer, High Speed	120	3	0.1	36.036	9.72	Medium	2011
2	HU-2011-1220	2011-01-01 00:00:00	2011-05-01 00:00:00	Second Class	Annie Thurman	Consumer	Budapest	Hungary	EMEA	EMEA	OFF-TEN-10001585	Office Supplies	Storage	Tenex Box, Single Width	66	4	0.0	29.640	8.17	High	2011
3	IT-2011-3647632	2011-01-01 00:00:00	2011-05-01 00:00:00	Second Class	Eugene Moren	Home Office	Stockholm	Sweden	EU	North	OFF-PA-10001492	Office Supplies	Paper	Enermax Note Cards, Premium	45	3	0.5	-26.055	4.82	High	2011
4	IN-2011-47883	2011-01-01 00:00:00	2011-08-01 00:00:00	Standard Class	Joseph Holt	Consumer	New South Wales	Australia	APAC	Oceania	FUR-FU-10003447	Furniture	Furnishings	Eldon Light Bulb, Duo Pack	114	5	0.1	37.770	4.70	Medium	2011
5	IN-2011-47883	2011-01-01 00:00:00	2011-08-01 00:00:00	Standard Class	Joseph Holt	Consumer	New South Wales	Australia	APAC	Oceania	OFF-PA-10001968	Office Supplies	Paper	Eaton Computer Printout Paper, 8.5 x 11	55	2	0.1	15.342	1.80	Medium	2011
6	CA-2011-1510	2011-02-01 00:00:00	2011-06-01 00:00:00	Standard Class	Magdelene Morse	Consumer	Ontario	Canada	Canada	Canada	TEC-OKI-10002750	Technology	Machines	Okidata Inkjet, Wireless	314	1	0.0	3.120	24.10	Medium	2011
7	IN-2011-79397	2011-03-01 00:00:00	2011-03-01 00:00:00	Same Day	Kean Nguyen	Corporate	New South Wales	Australia	APAC	Oceania	OFF-AP-10000304	Office Supplies	Appliances	Hoover Microwave, White	276	1	0.1	110.412	125.32	Critical	2011
8	ID-2011-80230	2011-03-01 00:00:00	2011-09-01 00:00:00	Standard Class	Ken Lonsdale	Consumer	Auckland	New Zealand	APAC	Oceania	TEC-CO-10004182	Technology	Copiers	Hewlett Wireless Fax, Laser	912	4	0.4	-319.464	107.10	Low	2011
9	IZ-2011-4680	2011-03-01 00:00:00	2011-07-01 00:00:00	Standard Class	Lindsay Williams	Corporate	Ninawa	Iraq	EMEA	EMEA	FUR-NOV-10002791	Furniture	Chairs	Novimex Swivel Stool, Set of Two	667	4	0.0	253.320	81.26	High	2011

	order_id	order_date	ship_date	ship_mode	customer_name	segment	state	country	market	region	product_id	category	sub_category	product_name	sales	quantity	discount	profit	shipping_cost	order_priority	year
51280	TZ-2014-8220	31-12-2014	2015-06-01 00:00:00	Standard Class	Christine Kargatis	Home Office	Dar Es Salaam	Tanzania	Africa	Africa	OFF-HAR-10001531	Office Supplies	Labels	Harbour Creations Removable Labels, Adjustable	50	6	0.0	6.8400	2.15	Medium	2014
51281	CA-2014-115427	31-12-2014	2015-04-01 00:00:00	Standard Class	Erica Bern	Corporate	California	United States	US	West	OFF-BI-10004632	Office Supplies	Binders	GBC Binding covers	21	2	0.2	6.4750	2.06	Medium	2014
51282	UP-2014-4410	31-12-2014	2015-04-01 00:00:00	Standard Class	Guy Thornton	Consumer	Zaporizhzhya	Ukraine	EMEA	EMEA	OFF-AVE-10003558	Office Supplies	Labels	Avery Round Labels, Alphabetical	28	4	0.0	6.1200	1.70	Medium	2014
51283	IN-2014-23754	31-12-2014	2015-07-01 00:00:00	Standard Class	Kalyca Meade	Corporate	Guangdong	China	APAC	North Asia	OFF-PA-10004727	Office Supplies	Paper	Eaton Note Cards, 8.5 x 11	79	3	0.0	25.3800	1.41	Medium	2014
51284	MX-2014-108574	31-12-2014	2015-04-01 00:00:00	Standard Class	Julia Barnett	Home Office	Tamaulipas	Mexico	LATAM	North	OFF-LA-10004969	Office Supplies	Labels	Novimex Legal Exhibit Labels, Adjustable	17	3	0.0	0.6600	1.32	Medium	2014
51285	CA-2014-115427	31-12-2014	2015-04-01 00:00:00	Standard Class	Erica Bern	Corporate	California	United States	US	West	OFF-BI-10002103	Office Supplies	Binders	Cardinal Slant-D Ring Binder, Heavy Gauge Vinyl	14	2	0.2	4.5188	0.89	Medium	2014
51286	MO-2014-2560	31-12-2014	2015-05-01 00:00:00	Standard Class	Liz Preis	Consumer	Souss-Massa-Draâ	Morocco	Africa	Africa	OFF-WIL-10001069	Office Supplies	Binders	Wilson Jones Hole Reinforcements, Clear	4	1	0.0	0.4200	0.49	Medium	2014
51287	MX-2014-110527	31-12-2014	2015-02-01 00:00:00	Second Class	Charlotte Melton	Consumer	Managua	Nicaragua	LATAM	Central	OFF-LA-10004182	Office Supplies	Labels	Hon Color Coded Labels, 5000 Label Set	26	3	0.0	12.3600	0.35	Medium	2014
51288	MX-2014-114783	31-12-2014	2015-06-01 00:00:00	Standard Class	Tamara Dahlen	Consumer	Chihuahua	Mexico	LATAM	North	OFF-LA-10000413	Office Supplies	Labels	Hon Legal Exhibit Labels, Alphabetical	7	1	0.0	0.5600	0.20	Medium	2014
51289	CA-2014-156720	31-12-2014	2015-04-01 00:00:00	Standard Class	Jill Matthias	Consumer	Colorado	United States	US	West	OFF-FA-10003472	Office Supplies	Fasteners	Bagged Rubber Bands	3	3	0.2	-0.6048	0.17	Medium	2014

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block